// 配送区域
const {DataTypes, db } = require("../db");
db.define('area', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:'租户ID'}, 
name:{type: DataTypes.STRING(100),comment:'区域名称'}, 
carsId:{type: DataTypes.INTEGER,comment:'车牌号'}, 
path:{type: DataTypes.TEXT,comment:'路径'}, 
salesId:{type: DataTypes.INTEGER,comment:'业务员'}, 
bfDate:{type: DataTypes.STRING(255),comment:'拜访时间周一。。日'}, 
bak1:{type: DataTypes.STRING(255),comment:''}, 

}, {
    tableName: 'area',
    timestamps: false,
    comment: '配送区域',
    indexes:[{"unique":true,"name":"区域名称唯一","fields":["tenantId"," name"]}]
});